Introduction

The purpose of this document is to consolidate and review the CTD Rosette data collected during the ASPIRE campaign. In Step 1, The data are downloaded from the data landing pages and the file paths are reviewed. In Step 2, the file types are counted and compared to what is recorded in the ASPIRE data inventory. Step 3 runs a QAQC check on the spatial data provided in the CTD files. Steps 4 and 5 compute summary statistics for each sensor used on each cast, creates boxplots for each cast depth, and profile plots for each sensor.

The ASPIRE campaign was conducted from 2018 to 2022. The information presented here is from Okeanos Explorer CTD Rosette data collected in the following regions: SOUTH ATLANTIC, SOUTH ATLANTIC BIGHT, CARIBBEAN, SOUTHEAST US, NORTHEAST U.S. & CANADA, No Record, Puerto Rico.

1Step 1: Download the CTD Rosette files

Table 1. File paths for CTD Rosette data downloaded from data Landing Pages . The function that creates this table downloads all of the Shipboard CTD data from the DLPs, looks for the presence key folders (“Profile_Data,”CTD”, and “SHIPCTD”), and documents the file paths to each dataset. The goal is for all file paths to be identical.

After creating table 1, manually fix file paths and rerun to see results (optional).

Table 2. File paths for CTD Rosette data downloaded from Data Landing Pages (DLP) with updates.

Step 2: Count and compare

Table 3. Comparison of .hex and .cnv files for each expedition with the ASPIRE data inventory.

If possible, use Seabird SeaTerm software (https://www.seabird.com/software) to convert the hex files to cnv files where missing and rerun the table above. At this point you can determine which expedition folders are missing CTD Rosette files. Follow up with NCEI to get files.

Step 3: Check latitude and longitude

Do all casts have latitude and longitude in the metadata?

Table 4. CTD Rosette casts without latitude and longitude in the metadata.

Map all casts locations

Step 4: Check sensors

Table 5. Sensors used and units of measure for each cast.

Across all casts, the units for each sensor used should be consistent. The oxygen sensors are the most likely to be mixed as there are multiple sensors and units for output and you can assign any unit to any output (labeled oxygen, oxygen2, and oxygen3). Any record of a sensor not being used should be checked in the .hex file and with what is recorded in the CTD Summary Doc to make sure the data were not omitted in the transformation from .hex to .cnv.

Step 5: Run summary statistics

Table 6. Summary statistics for each sensor used on each cast. Blank cells indicate the sensor was not in use.

Table 7. Casts and sensors with negative or 0 values. Note that expeditions EX 1903L1, EX1905L1, and EX1906 did not have turbidity in the original export, probably for good reason. EX1810 had turbidity included in the original export, but all values are 0s. EX1905L1 collected dissolved oxygen in ml/L but EX1810 collected it in mg/L. It is unclear why data values are negative in each instance. Of the 15 casts where fluorescence was collected, 12 have negative data values, tbd on whether this is expected. A CTD Summary Form with documentation of calibration would help clarify whether these data were intentionally omitted from the initial export or are “bad data”.

Table 8. Casts with oxygen saturation (%) greater than 100%

Step 6: Plot the data

Plots

Depth boxplots

Fig. 2. Box-plots of each CTD Rosette cast by expedition

Oxygen sensor boxplots

**Fig. 3.** Box-plots of oxygen (%) for each cast.

Fig. 3. Box-plots of oxygen (%) for each cast.

**Figs. 4.** Box-plots of oxygen (mg/L) for each cast.

Figs. 4. Box-plots of oxygen (mg/L) for each cast.

All sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

**Figs. 5-31.** Profiles for all sensors by expedition

Figs. 5-31. Profiles for all sensors by expedition

Sensor profiles

Temperature

Conductivity

Salinity

Density

Oxygen (%)

Oxygen (mg/L)

Oxygen reduction potential

Turbidity

Fluorescence

Sound speed

Nitrogen